<?php

echo "Inhalt der Datei: kneipenAnzeigen2.inc.php";

include 'includes/db_mysqli_connect.inc.php';

$sql_query = "SELECT * FROM kneipen";
$result = $db_con->query($sql_query) or die ("Fehlermeldung=". $db_con->error());


echo "<table id=\"myTable\" class=\"tablesorter\">";
echo "<thead>";
echo "<tr><th>Name</th><th>Art</th><th>Note</th><th>Kommentar</th></tr>";
echo "</thead>";
echo "<tbody>";
while (($row = $result->fetch_assoc()) !== NULL) {
    echo "<tr>";
    echo "<td>" . $row['Name'] . "</td>";
    echo "<td>" . $row['Art'] . "</td>";
    echo "<td>" . $row['Note'] . "</td>";
    echo "<td>" . $row['Kommentar'] . "</td>";
    echo "</tr>";
}
echo "</tbody>";
echo "</table>";
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
?>
